home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
The World of Computer Software
/
The World of Computer Software.iso
/
trfdemo1.zip
/
PRINTOUT.TXT
< prev
next >
Wrap
Text File
|
1991-02-13
|
55KB
|
1,014 lines
TRF
Mechanical Estimating System
Sample Reports
The TRF Mechanical Estimating System is the most powerful, flexible, and
user friendly estimating system available in todays market. The system can
provide reports in various formats enabling the user to access a large amount
of information quickly & precisely. Some unique features available with
the system are:
1. The Bid can be extended in many different formats. One of the
most useful reports prints out the extensions at the assembly
level instead of at the parts level as is required by other
systems.
2. The report can print out each assembly as an extended Part or
as a unit price. Very frequently you are asked to provide unit
prices as part of a bid, now you can do it as one easy step.
3. You can select to print out all your reports to disk rather
than your printer. This will enable you to retrieve them from
a word processor and format them for printing on your letter
head.
4. The reports can be printed with the takeoff grouped by System,
Job Cost Code, and Product Code in the same bid summary.
5. The bid can be extended using either the Standard Labor &
Material Units, normally called Change Order Units or
by Bid Labor & Material Units.
6. The system enables you to create Take-Off Entry Worksheets
that can be used for take off and then handed to clerical,
personnel for input to the computer.
7. You can print out various Bid Summary reports including Bid
Analysis and Square Footage Reports, enabling a quick analysis
of a particular job.
8. After completing a takeoff you can print a consolidated
material quote sheet that will allow you to get a better
price from your supplier.
Index
Report Samples Contained on Disk
1. Unit Price Extension
2. Total Price extension
3. Parts Extension Sorted By System
4. Parts Extension Sorted By Job Cost Code
5 Parts Extension Sorted By Commodity Code
6. Recap Sheet - Brief Takeoff Recap
7. Recap By System with Square Foot Analysis
8. Job Recap By Cost Code
9. Bid Summary Analysis
10. Vendor Quote Sheet
11. Warehouse Material Pull List
12. Consolidated Material List
13. Project Specification
14. Sample Proposal Letter
TRF International, Inc.
JOB: 15-ED * B I D T A K E - O F F D E T A I L S * 02-03-91 0:49 Pg: 1
Test Job BID DATE MATERIAL LABOR MATERIAL LABOR LABOR
Wilson Const 01-29-91 TAX TAX M/U M/U RATE
6.000% EXEMPT 1.20 1.20 $30.00
1=DIFFICULTY FACTOR LABOR LABOR MATERIAL UNIT UNIT
ASSM SYS LOC D E S C R I P T I O N COUNT UNIT COST COST COST PRICE
==============================================================================================
1 1 1 Underground Sanitary
3007 1 1 4"X5' PIPE CI SH P/FT 60 .230 6.90 3.85 10.75 12.90
4" 1/4 Bend Hub 3 .830 24.90 7.31 32.21 38.65
4" 1/4 Bend Long Swp Hub 1 .890 26.70 11.26 37.96 45.55
6"x4" Y & 1/8 Bnd Hub 1 2.000 60.00 22.63 82.63 99.16
4"x4" Y & 1/8 Bnd Hub 1 1.580 47.40 13.74 61.14 73.37
Exc 2'x3' trench <=5" pipe 60 .200 6.00 6.00 7.20
---- ----- ------ ------- -------- ------
***** 1 System Totals: 32.76 983 300 1,283 1,540
==============================================================================================
2 2 2 Above Ground Sanitary
4008 2 2 4"X10' PIPE CI NH P/FT 10 .200 6.00 2.93 8.93 10.72
4" Bend 1/4 Reg NH 1 .750 22.50 4.62 27.12 32.55
4x4x10x16" Closet Bend PE NH 1 .750 22.50 17.89 40.39 48.47
4107 2 2 3" CI NH 10ft w/HNGR 10 .261 7.83 2.77 10.60 12.72
3"x2" Comb. Dbl Y & 1/8 NH 1 .920 27.60 8.85 36.45 43.74
---- ----- ------ ------- ------ -------
***** 2 System Totals: 7.03 211 88 299 359
==============================================================================================
3 3 3 Domestic Cold Water
20801 3 3 3/4" Cop L w/Hngr & Shld 75 .288 8.65 1.49 10.13 12.16
3/4" Cop 90 Ell CxC 4 .540 16.20 .41 16.61 19.94
3/4" Tee CxCxC 1 .770 23.10 .77 23.87 28.64
1/2x6" Air Chamber 1 .410 12.30 1.21 13.51 16.21
3/4" Copper Union CxC 1 .540 16.20 1.75 17.95 21.54
---- ----- ------ ------- ------- ------
***** 3 System Totals: 25.50 765 117 882 1,058
==============================================================================================
TRF International, Inc.
JOB: 15-ED * B I D T A K E - O F F D E T A I L S * 02-05-91 14:05 Pg: 1
Test Job BID DATE MATERIAL LABOR MATERIAL LABOR LABOR
Wilson Const 01-29-91 TAX TAX M/U M/U RATE
6.000% EXEMPT 1.20 1.20 $30.00
1=DIFFICULTY FACTOR LABOR LABOR MATERIAL UNIT EXTEND
ASSM SYS LOC D E S C R I P T I O N COUNT UNIT COST COST COST PRICE
==============================================================================================
1 1 1 Underground Sanitary
3007 1 1 4"X5' PIPE CI SH P/FT 60
4"x5' Pipe CI SH P/ft 60 .230 6.90 3.85 10.75 773.80
4" 1/4 Bend Hub 3 .830 24.90 7.31 32.21 115.94
4" 1/4 Bend Long Swp Hub 1 .890 26.70 11.26 37.96 45.55
6"x4" Y & 1/8 Bnd Hub 1 2.000 60.00 22.63 82.63 99.16
4"x4" Y & 1/8 Bnd Hub 1 1.580 47.40 13.74 61.14 73.37
Exc 2'x3' trench <=5" pipe 60 .200 6.00 6.00 432.00
---- ----- ------ ------- ------- -------
***** 1 System Totals: 32.76 983 300 1,283 1,540
==============================================================================================
2 2 2 Above Ground Sanitary
4008 2 2 4"X10' PIPE CI NH P/FT 10
4"x10' Pipe CI NH P/ft 10 .200 6.00 2.93 8.93 107.19
4" Bend 1/4 Reg NH 1 .750 22.50 4.62 27.12 32.55
4x4x10x16" Closet Bend PE NH 1 .750 22.50 17.89 40.39 48.47
4107 2 2 3" CI NH 10ft w/HNGR 10
3"x10' Pipe CI NH P/ft 10 .150 4.50 2.27 6.77 81.21
3" Coupling NH 1 1.76 1.76 2.12
3" Hngr Clevis Blk 1 1.110 33.30 1.13 34.43 41.32
10-1/2-PL REG HEX NUT 3 .06 .06 .21
11-1/2 ROUND FLAT WASHERS 3 .04 .04 .16
355-PL STEEL CONCRETE INSERT 1 .66 .66 .79
50-1/2-PL ALL THRD ROD P/FT 3 .40 .40 1.44
3"x2" Comb. Dbl Y & 1/8 NH 1 .920 27.60 8.85 36.45 43.74
---- ----- ------ ------- ------- -------
***** 2 System Totals: 7.03 211 88 299 359
==============================================================================================
3 3 3 Domestic Cold Water
20801 3 3 3/4" Cop L w/Hngr & Shld 75
3/4" Pipe Cop L Hard 75 .060 1.80 .81 2.61 234.66
4" Dia Ins Shld 12"x18ga 10 .230 6.90 1.85 8.75 110.30
4" Hngr Clevis Blk 10 1.400 42.00 1.39 43.39 546.66
10-3/8-PL REG HEX NUT 32 .03 .03 1.21
11-3/8 ROUND FLAT WASHERS 32 .03 .03 1.22
355-PL STEEL CONCRETE INSERT 10 .66 .66 8.32
50-3/8-PL ALL THRD ROD P/FT 32 .25 .25 9.76
3/4" Cop 90 Ell CxC 4 .540 16.20 .41 16.61 79.74
3/4" Tee CxCxC 1 .770 23.10 .77 23.87 28.64
1/2x6" Air Chamber 1 .410 12.30 1.21 13.51 16.21
3/4" Copper Union CxC 1 .540 16.20 1.75 17.95 21.54
---- ----- ------ ------- ------- -------
***** 3 System Totals: 25.50 765 117 882 1,058
==============================================================================================
TRF International, Inc.
JOB: 15-ED * B I D T A K E - O F F D E T A I L S * 02-03-91 0:49 Pg: 1
Test Job BID DATE MATERIAL LABOR MATERIAL LABOR LABOR
Wilson Const 01-29-91 TAX TAX M/U M/U RATE
6.000% EXEMPT 1.20 1.20 $30.00
1=DIFFICULTY FACTOR LABOR LABOR MATERIAL UNIT UNIT
ASSM SYS LOC D E S C R I P T I O N COUNT UNIT COST COST COST PRICE
==============================================================================================
1 1 1 Underground Sanitary
3007 1 1 4"X5' PIPE CI SH P/FT 60
4"x5' Pipe CI SH P/ft 60 .230 6.90 3.85 10.75 12.90
4" 1/4 Bend Hub 3 .830 24.90 7.31 32.21 38.65
4" 1/4 Bend Long Swp Hub 1 .890 26.70 11.26 37.96 45.55
6"x4" Y & 1/8 Bnd Hub 1 2.000 60.00 22.63 82.63 99.16
4"x4" Y & 1/8 Bnd Hub 1 1.580 47.40 13.74 61.14 73.37
Exc 2'x3' trench <=5" pipe 60 .200 6.00 6.00 7.20
---- ----- ------ ------- ------- ------
***** 1 System Totals: 32.76 983 300 1,283 1,540
==============================================================================================
2 2 2 Above Ground Sanitary
4008 2 2 4"X10' PIPE CI NH P/FT 10
4"x10' Pipe CI NH P/ft 10 .200 6.00 2.93 8.93 10.72
4" Bend 1/4 Reg NH 1 .750 22.50 4.62 27.12 32.55
4x4x10x16" Closet Bend PE NH 1 .750 22.50 17.89 40.39 48.47
4107 2 2 3" CI NH 10ft w/HNGR 10
3"x10' Pipe CI NH P/ft 10 .150 4.50 2.27 6.77 8.12
3" Coupling NH 1 1.76 1.76 2.12
3" Hngr Clevis Blk 1 1.110 33.30 1.13 34.43 41.32
10-1/2-PL REG HEX NUT 3 .06 .06 .07
11-1/2 ROUND FLAT WASHERS 3 .04 .04 .05
355-PL STEEL CONCRETE INSERT 1 .66 .66 .79
50-1/2-PL ALL THRD ROD P/FT 3 .40 .40 .48
3"x2" Comb. Dbl Y & 1/8 NH 1 .920 27.60 8.85 36.45 43.74
---- ----- ------ ------- ------- ------
***** 2 System Totals: 7.03 211 88 299 359
==============================================================================================
3 3 3 Domestic Cold Water
20801 3 3 3/4" Cop L w/Hngr & Shld 75
3/4" Pipe Cop L Hard 75 .060 1.80 .81 2.61 3.13
4" Dia Ins Shld 12"x18ga 10 .230 6.90 1.85 8.75 10.50
4" Hngr Clevis Blk 10 1.400 42.00 1.39 43.39 52.06
10-3/8-PL REG HEX NUT 32 .03 .03 .04
11-3/8 ROUND FLAT WASHERS 32 .03 .03 .04
355-PL STEEL CONCRETE INSERT 10 .66 .66 .79
50-3/8-PL ALL THRD ROD P/FT 32 .25 .25 .30
3/4" Cop 90 Ell CxC 4 .540 16.20 .41 16.61 19.94
3/4" Tee CxCxC 1 .770 23.10 .77 23.87 28.64
1/2x6" Air Chamber 1 .410 12.30 1.21 13.51 16.21
3/4" Copper Union CxC 1 .540 16.20 1.75 17.95 21.54
---- ----- ------ ------- ------- ------
***** 3 System Totals: 25.50 765 117 882 1,058
TRF International, Inc.
JOB: 15-ED * B I D T A K E - O F F D E T A I L S * 02-01-91 11:18 Pg: 1
Test Job BID DATE MATERIAL LABOR MATERIAL LABOR LABOR
Wilson Const 01-29-91 TAX TAX M/U M/U RATE
6.000% EXEMPT 1.20 1.20 $30.00
1=DIFFICULTY FACTOR --- LABOR --- ---- MATERIAL ----
ASSM SYS LOC D E S C R I P T I O N COUNT UNIT HOURS UNIT EXTEND
==============================================================================================
4"x5' Pipe CI SH P/ft 60 .230 13.80 3.847 230.82
4" 1/4 Bend Hub 3 .830 2.49 7.306 21.92
4" 1/4 Bend Long Swp Hub 1 .890 .89 11.256 11.25
4"x4" Y & 1/8 Bnd Hub 1 1.580 1.58 13.743 13.74
6"x4" Y & 1/8 Bnd Hub 1 2.000 2.00 22.629 22.62
Exc 2'x3' trench <=5" pipe 60 .200 12.00
------ --------
***** 1 System Totals: 32.76 300.37
==============================================================================================
3"x10' Pipe CI NH P/ft 10 .150 1.50 2.267 22.67
4"x10' Pipe CI NH P/ft 10 .200 2.00 2.932 29.32
4x4x10x16" Closet Bend PE NH 1 .750 .75 17.890 17.89
4" Bend 1/4 Reg NH 1 .750 .75 4.622 4.62
3"x2" Comb. Dbl Y & 1/8 NH 1 .920 .92 8.849 8.84
3" Coupling NH 1 1.762 1.76
3" Hngr Clevis Blk 1 1.110 1.11 1.130 1.13
10-1/2-PL REG HEX NUT 3 .057 .17
11-1/2 ROUND FLAT WASHERS 3 .043 .12
355-PL STEEL CONCRETE INSERT 1 .660 .66
50-1/2-PL ALL THRD ROD P/FT 3 .400 1.20
------ -------
***** 2 System Totals: 7.03 88.42
==============================================================================================
3/4" Pipe Cop L Hard 75 .060 4.50 .807 60.54
3/4" Copper Union CxC 1 .540 .54 1.749 1.74
3/4" Cop 90 Ell CxC 4 .540 2.16 .413 1.65
3/4" Tee CxCxC 1 .770 .77 .769 .76
1/2x6" Air Chamber 1 .410 .41 1.208 1.20
4" Dia Ins Shld 12"x18ga 10 .230 2.41 1.853 19.46
4" Hngr Clevis Blk 10 1.400 14.70 1.385 14.54
10-3/8-PL REG HEX NUT 32 .031 1.00
11-3/8 ROUND FLAT WASHERS 32 .031 1.01
355-PL STEEL CONCRETE INSERT 10 .660 6.93
50-3/8-PL ALL THRD ROD P/FT 32 .252 8.13
------ -------
***** 3 System Totals: 25.49 117.03
TRF International, Inc.
JOB: 15-ED * TAKE-OFF PARTS SUMMARIZED BY COST CODE * 02-01-91 11:18 Pg:1
Test Job BID DATE MATERIAL LABOR MATERIAL LABOR LABOR
Wilson Const 01-29-91 TAX TAX M/U M/U RATE
6.000% EXEMPT 1.20 1.20 $30.00
1=DIFFICULTY FACTOR ------ LABOR ------ --- MATERIAL----
PART NUMBER D E S C R I P T I O N COUNT UNIT HOURS % TTL UNIT EXTEND
==============================================================================================
Account Code: 330 - Copper Type L P&F
462PCER0144 3/4" Pipe Cop L Hard 75 .060 4.50 6.9 .807 60.54
543PNIB0070 3/4" Copper Union CxC 1 .540 .54 .8 1.749 1.74
544PNIB0785 3/4" Cop 90 Ell CxC 4 .540 2.16 3.3 .413 1.65
544PNIB0885 3/4" Tee CxCxC 1 .770 .77 1.2 .769 .76
544PNIB1705 1/2x6" Air Chamber 1 .410 .41 .6 1.208 1.20
------ ----- -------
Subtotal: Copper Type L P&F 8.38 12.8% 65.92
==============================================================================================
Account Code: 352 - CI Hub P&F
413PTYP0119 4"x5' Pipe CI SH P/ft 60 .230 13.80 21.1 3.847 230.82
503PTYP0149 4" 1/4 Bend Hub 3 .830 2.49 3.8 7.306 21.92
503PTYP0210 4" 1/4 Bend Long Swp Hub 1 .890 .89 1.4 11.256 11.25
503PTYP0415 4"x4" Y & 1/8 Bnd Hub 1 1.580 1.58 2.4 13.743 13.74
503PTYP0445 6"x4" Y & 1/8 Bnd Hub 1 2.000 2.00 3.1 22.629 22.62
------ ----- ------- -------
Subtotal: CI Hub P&F 20.76 31.8% 300.37
==============================================================================================
Account Code: 354 - CI No Hub P&F
415PTYP0029 3"x10' Pipe CI NH P/ft 10 .150 1.50 2.3 2.267 22.67
415PTYP0039 4"x10' Pipe CI NH P/ft 10 .200 2.00 3.1 2.932 29.32
505PTYP0020 4x4x10x16" Closet Bend PE NH 1 .750 .75 1.1 17.890 17.89
505PTYP0145 4" Bend 1/4 Reg NH 1 .750 .75 1.1 4.622 4.62
505PTYP0395 3"x2" Comb. Dbl Y & 1/8 NH 1 .920 .92 1.4 8.849 8.84
505PTYP0570 3" Coupling NH 1 1.762 1.76
------ ----- ------- -------
Subtotal: CI No Hub P&F 5.92 9.1% 85.12
==============================================================================================
Account Code: 420 - Hangers, Supports & Sleeves
581PITG0570 4" Dia Ins Shld 12"x18ga 10 .230 2.41 3.7 1.853 19.46
581PITG1520 3" Hngr Clevis Blk 1 1.110 1.11 1.7 1.130 1.13
581PITG1550 4" Hngr Clevis Blk 10 1.400 14.70 22.5 1.385 14.54
581PMIH0055 10-1/2-PL REG HEX NUT 3 .057 .17
581PMIH0070 10-3/8-PL REG HEX NUT 32 .031 1.00
581PMIH0250 11-1/2 ROUND FLAT WASHERS 3 .043 .12
581PMIH0265 11-3/8 ROUND FLAT WASHERS 32 .031 1.01
581PMIH1180 355-PL STEEL CONCRETE INSERT 11 .660 7.59
581PMIH1475 50-1/2-PL ALL THRD ROD P/FT 3 .400 1.20
581PMIH1500 50-3/8-PL ALL THRD ROD P/FT 32 .252 8.13
------ ----- --------
Subtotal: Hangers, Supports & Sleeves 18.22 27.9% 54.40
==============================================================================================
Account Code: 430 - Excavation & Backfill
990PEXC0005A Exc 2'x3' trench <=5" pipe 60 .200 12.00 18.4
------ ----- --------
Subtotal: Excavation & Backfill 12.00 18.4%
TRF International, Inc.
JOB: 15-ED * TAKE-OFF PARTS SUMMARIZED BY PRODUCT TYPE * 02-01-91 11:18 Pg:1
Test Job BID DATE MATERIAL LABOR MATERIAL LABOR LABOR
Wilson Const 01-29-91 TAX TAX M/U M/U RATE
6.000% EXEMPT 1.20 1.20 $30.00
1=DIFFICULTY FACTOR ------ LABOR ----- ---- MATERIAL----
PART NUMBER D E S C R I P T I O N COUNT UNIT HOURS % TTL UNIT EXTEND
==============================================================================================
Product Code: 413p - *PIPE CAST IRON SOIL B&S
413PTYP0119 4"x5' Pipe CI SH P/ft 60 .230 13.80 21.1 3.847 230.82
------ ----- --------
Subtotal: *PIPE CAST IRON SOIL B&S 13.80 21.1% 230.82
==============================================================================================
Product Code: 415p - *PIPE CAST IRON SOIL NH
415PTYP0029 3"x10' Pipe CI NH P/ft 10 .150 1.50 2.3 2.267 22.67
415PTYP0039 4"x10' Pipe CI NH P/ft 10 .200 2.00 3.1 2.932 29.32
------ ----- -------
Subtotal: *PIPE CAST IRON SOIL NH 3.50 5.4% 52.00
==============================================================================================
Product Code: 462p - *TUBING COPPER WATER
462PCER0144 3/4" Pipe Cop L Hard 75 .060 4.50 6.9 .807 60.54
------ ----- -------
Subtotal: *TUBING COPPER WATER 4.50 6.9% 60.54
==============================================================================================
Product Code: 503p - *PIPE FITTINGS CAST IRON B&S
503PTYP0149 4" 1/4 Bend Hub 3 .830 2.49 3.8 7.306 21.92
503PTYP0210 4" 1/4 Bend Long Swp Hub 1 .890 .89 1.4 11.256 11.25
503PTYP0415 4"x4" Y & 1/8 Bnd Hub 1 1.580 1.58 2.4 13.743 13.74
503PTYP0445 6"x4" Y & 1/8 Bnd Hub 1 2.000 2.00 3.1 22.629 22.62
------ ----- -------
Subtotal: *PIPE FITTINGS CAST IRON B&S 6.96 10.7% 69.54
==============================================================================================
Product Code: 505p - *PIPE FITTINGS NO HUB
505PTYP0020 4x4x10x16" Closet Bend PE NH 1 .750 .75 1.1 17.890 17.89
505PTYP0145 4" Bend 1/4 Reg NH 1 .750 .75 1.1 4.622 4.62
505PTYP0395 3"x2" Comb. Dbl Y & 1/8 NH 1 .920 .92 1.4 8.849 8.84
505PTYP0570 3" Coupling NH 1 1.762 1.76
------ ----- --------
Subtotal: *PIPE FITTINGS NO HUB 2.42 3.7% 33.12
==============================================================================================
Product Code: 543p - *TUBE FITTINGS COP PRESS CAST
543PNIB0070 3/4" Copper Union CxC 1 .540 .54 .8 1.749 1.74
------ ----- ------
Subtotal: *TUBE FITTINGS COP PRESS CAST .54 .8% 1.74
==============================================================================================
Product Code: 544p - *TUBE FITTINGS COP PRESS WROT
544PNIB0785 3/4" Cop 90 Ell CxC 4 .540 2.16 3.3 .413 1.65
544PNIB0885 3/4" Tee CxCxC 1 .770 .77 1.2 .769 .76
544PNIB1705 1/2x6" Air Chamber 1 .410 .41 .6 1.208 1.20
------ ----- --------
Subtotal: *TUBE FITTINGS COP PRESS WROT 3.34 5.1% 3.63
==============================================================================================
TRF International, Inc.
JOB: 15-ED * TAKE-OFF PARTS SUMMARIZED BY PRODUCT TYPE * 02-01-91 11:18 Pg: 2
Test Job BID DATE MATERIAL LABOR MATERIAL LABOR LABOR
Wilson Const 01-29-91 TAX TAX M/U M/U RATE
6.000% EXEMPT 1.20 1.20 $30.00
1=DIFFICULTY FACTOR ---- LABOR ---- --- MATERIAL ---
PART NUMBER D E S C R I P T I O N COUNT UNIT HOURS % TTL UNIT EXTEND
==============================================================================================
Product Code: 581p - *PIPE HANGERS
581PITG0570 4" Dia Ins Shld 12"x18ga 10 .230 2.41 3.7 1.853 19.46
581PITG1520 3" Hngr Clevis Blk 1 1.110 1.11 1.7 1.130 1.13
581PITG1550 4" Hngr Clevis Blk 10 1.400 14.70 22.5 1.385 14.54
581PMIH0055 10-1/2-PL REG HEX NUT 3 .057 .17
581PMIH0070 10-3/8-PL REG HEX NUT 32 .031 1.00
581PMIH0250 11-1/2 ROUND FLAT WASHERS 3 .043 .12
581PMIH0265 11-3/8 ROUND FLAT WASHERS 32 .031 1.01
581PMIH1180 355-PL STEEL CONCRETE INSERT 11 .660 7.59
581PMIH1475 50-1/2-PL ALL THRD ROD P/FT 3 .400 1.20
581PMIH1500 50-3/8-PL ALL THRD ROD P/FT 32 .252 8.13
------ ----- --------
Subtotal: *PIPE HANGERS 18.22 27.9% 54.40
==============================================================================================
Product Code: 990p - *Excavation & Backfill
990PEXC0005A Exc 2'x3' trench <=5" pipe 60 .200 12.00 18.4
------ ----- --------
Subtotal: *Excavation & Backfill 12.00 18.4%
==============================================================================================
Bid Totals: 65.28 505.84
TRF International, Inc.
JOB: 15-ED * A B B R E V I A T E D B I D R E C A P * 02-01-91 11:18 Pg: 2
Test Job BID DATE MATERIAL LABOR MATERIAL LABOR LABOR
Wilson Const 01-29-91 TAX TAX M/U M/U RATE
6.000% EXEMPT 1.20 1.20 $30.00
==============================================================================================
MAN HOURS: 65.29 LABOR COST: 1,959
LABOR MARGIN: 392
* * *Q U O T E M A T E R I A L S* * *
ACT COST TAX M/UP PRICE
M100 Fixtures
8,200.00 492.00 1.15 9,995.80
M103 Water Heaters
680.00 40.80 1.20 864.96
MATERIAL COST: 9,919
MATERIAL MARGIN: 1,549
LABOR + MATERIAL COST: 11,878
LABOR + MATERIAL MARGIN: 1,941
CONSTRUCTION PRICE: 13,819
* * * * J O B E X P E N S E S * * * *
ACT COST TAX M/UP PRICE
E 1 SUPERVISION
250.00 1.40 350.00
E 7 Permits
100.00 1.00 100.00
E 13 Small Tools
235.00 1.00 235.00
JOB EXPENSE NET COST: 585
JOB EXPENSE MARGIN: 100
TOTAL BID PRICE: 14,504
TRF International, Inc.
* * SYSTEM / SQUARE FOOTAGE BREAKDOWN * *
02-01-91 11:18 Pg: 1
BID NAME: Test Job SQUARE FOOTAGE : 3,500
BID NUMBER: 15 SALES TAXES : MAT=6.000% LAB=EXEMPT
BID DATE: 01-29-91 TAKE-OFF MATERIAL MARKUP: 20%
ESTIMATOR: ED HOURLY LABOR RATE : $30.00
JOB ADDRESS: LABOR MARKUP : 20%
CUSTOMER: Wilson Cost LABOR DIFFICULTY : LEVEL 1
COSTS % OF COST PER LABOR % OF HOUR PER
SYSTEM SYSTEM NAME TAXED TOTAL SQ. FT. HOURS TOTAL SQ.FT.
==============================================================================================
**** BID TAKE-OFF ITEMS ****
1 Underground Sanitary 300.37 59.38 .0858 32.76 50.2 .0094
2 Above Ground Sanitary 88.42 17.48 .0253 7.03 10.8 .0020
3 Domestic Cold Water 117.03 23.14 .0334 25.49 39.1 .0073
---------- ------- ------- ------- ----- ---------
SUBTOTAL - BID TAKE-OFF ITEMS: 505.82 100.00 .1445 65.28 100.0 .0187
**** QUOTED MATERIALS ****
Fixtures 8,692.00 2.4834
Water Heaters 720.80 .2059
---------- -------- ---------
SUBTOTAL - QUOTED MATERIALS: 9,412.80 2.6894
*** EXPENSE ITEMS ****
SUPERVISION 250.00 .0714
Permits 100.00 .0286
Small Tools 235.00 .0671
---------- ------- ---------
SUBTOTAL - EXPENSE ITEMS: 585.00 .1671
GRAND TOTALS: 10,503.62 100.0 3.0010 65.28 100.0 .0187
========== ========= ======== ======= ===== ========
TRF International, Inc.
JOB: 15-ED * * * B I D R E C A P S H E E T * * * 02-01-91 11:18 Pg: 1
Test Job BID DATE MATERIAL LABOR MATERIAL LABOR LABOR
Wilson Const 01-29-91 TAX TAX M/U M/U RATE
6.000% EXEMPT 1.20 1.20 $30.00
==============================================================================================
-- L A B O R --
LOCATION ALLOCATION HOURS COST
1 Underground Sanitary 32.76 982.80
2 Above Ground Sanitary 7.03 210.90
3 Domestic Cold Water 25.49 764.85
-------- ---------
-- L A B O R -- -------- M A T E R I A L --------
ACCOUNT ALLOCATION - MATERIALS HOURS COST NET COST TAX GROSS M/UP
330 Copper Type L P&F 8.38 251.40 62.20 3.73 65.93 1.20
352 CI Hub P&F 20.76 622.80 283.38 17.00 300.38 1.20
354 CI No Hub P&F 5.92 177.60 80.31 4.82 85.13 1.20
420 Hangers, Supports & Sleeves 18.22 546.75 51.32 3.08 54.40 1.20
430 Excavation & Backfill 12.00 360.00
------- -------- --------- ------- -------- ----
TOTAL MATERIAL: 65.28 1,958.55 477.21 28.63 505.84 1.20
ACCOUNT ALLOCATION - QUOTED ITEMS NET COST TAX GROSS M/UP
100 Fixtures 8,200.00 492.00 8,692.00 1.15
103 Water Heaters 680.00 40.80 720.80 1.20
--------- ------- -------- ----
TOTAL QUOTED: 8,880.00 532.80 9,412.80 1.15
------- E X P E N S E S -------
JOB EXPENSE ALLOCATION NET COST TAX COST M/UP
1 SUPERVISION 250.00 250.00 1.40
7 Permits 100.00 100.00 1.00
13 Small Tools 235.00 235.00 1.00
--------- ------ ------- ----
TOTAL JOB EXPENSE: 585.00 585.00 1.17
TOTAL JOB COST: 11,900.76 561.43 12,462.19
TOTAL MARGIN: 2,040.84 1.16
--------- ====
TOTAL SELLING PRICE: 14,503.03
==========
TRF International, Inc.
* B I D S U M M A R Y A N A L Y S I S *
02-01-91 11:18 Pg: 1
BID NAME : Test Job SQUARE FOOTAGE : 3,500
BID NUMBER : 15 SALES TAXES : MAT=6.000% LAB=EXEMPT
BID DATE : 01-29-91 TAKE-OFF MATERIAL MARKUP: 20%
ESTIMATOR : ED HOURLY LABOR RATE :$30.00
JOB ADDRESS: LABOR MARKUP : 20%
CUSTOMER : Wilson Const LABOR DIFFICULTY : LEVEL 1
COST W/O SALES SELLING % OF COST PER SELL PER
SALES TAX TAX MARGIN PRICE SELL SQ. FT. SQ. FT.
==============================================================================================
LABOR 1,958.55 .00 391.71 2,350.26 16.2 .56 .67
MATERIAL 477.20 28.63 101.17 607.00 4.2 .14 .17
QUOTED 8,880.00 532.80 1,447.96 10,860.76 74.9 2.69 3.10
EXPENSE 585.00 .00 100.00 685.00 4.7 .17 .20
---------- --------- --------- ----------- ---- --------- --------
TOTALS 11,900.75 561.43 2,040.84 14,503.02 3.56 4.14
********************************************************************************************
* * * MATERIAL TO LABOR RATIOS * * *
(A) TOTAL LABOR HOURS: 65.29 (C) TAKE-OFF MATERIAL COST: 505.83
(B) TOTAL LABOR COST: 1,958.55 (D) QUOTED MATERIAL COST: 9,412.80
(E) TOTAL MATERIAL COST: 9,918.63
MATERIAL - LABOR RATIO (M to L)
TAKE-OFF MATERIAL COST (C) TO LABOR COST (B): 20.53% - 79.47% .26 to 1
QUOTED MATERIAL COST (D) TO LABOR COST (B) : 82.78% - 17.22% 4.81 to 1
TOTAL MATERIAL COST (E) TO LABOR COST (B) : 83.51% - 16.49% 5.06 to 1
02-03-91 00:39 TRF International, Inc. PAGE 1
15-ED Wilson Const Adnd #3 Test Job
* * * V E N D O R Q U O T E W O R K S H E E T * * *
DCI NUMBER D E S C R I P T I O N QUANTITY UNIT COST EXTENDED
1 67061050007 4"x5' Pipe CI SH P/ft 60 _______ ________
*PIPE CAST IRON SOIL B&S [413P] TOTAL: _______
2 67061000159 3"x10' Pipe CI NH P/ft 10 _______ _______
3 67061000161 4"x10' Pipe CI NH P/ft 10 _______ _______
*PIPE CAST IRON SOIL NH [415P] TOTAL: _______
4 64020140164 3/4" Pipe Cop L Hard 75 _______ _______
*TUBING COPPER WATER [462P] TOTAL: _______
5 67061050102 4" 1/4 Bend Hub 3 _______ _______
6 67061050382 4" 1/4 Bend Long Swp Hub 1 _______ _______
7 67061050806 4"x4" Y & 1/8 Bnd Hub 1 _______ _______
8 67061050813 6"x4" Y & 1/8 Bnd Hub 1 _______ _______
*PIPE FITTINGS CAST IRON B&S [503P] TOTAL: _______
9 67061020580 4x4x10x16" Closet Bend PE NH 1 _______ _______
10 67061000194 4" Bend 1/4 Reg NH 1 _______ _______
11 67061001804 3"x2" Comb. Dbl Y & 1/8 NH 1 _______ _______
12 67061000008 3" Coupling NH 1 _______ _______
*PIPE FITTINGS NO HUB [505P] TOTAL: _______
13 03992373798 3/4" Copper Union CxC 1 _______ _______
*TUBE FITTINGS COP PRESS CAST [543P] TOTAL: _______
14 03992372085 3/4" Cop 90 Ell CxC 4 _______ _______
15 03992372635 3/4" Tee CxCxC 1 _______ _______
16 03992373758 1/2x6" Air Chamber 1 _______ _______
*TUBE FITTINGS COP PRESS WROT [544P] TOTAL: _______
17 69029119208 4" Dia Ins Shld 12"x18ga 11 _______ _______
18 69029121028 3" Hngr Clevis Blk 1 _______ _______
19 69029121036 4" Hngr Clevis Blk 11 _______ _______
20 67055510066 10-1/2-PL REG HEX NUT 3 _______ _______
21 67055510064 10-3/8-PL REG HEX NUT 32 _______ _______
22 67055510120 11-1/2 ROUND FLAT WASHERS 3 _______ _______
23 67055510110 11-3/8 ROUND FLAT WASHERS 32 _______ _______
24 67055526500 355-PL STEEL CONCRETE INSERT 12 _______ _______
25 67055520864 50-1/2-PL ALL THRD ROD P/FT 3 _______ _______
26 67055520862 50-3/8-PL ALL THRD ROD P/FT 32 _______ _______
*PIPE HANGERS [581P] TOTAL: _______
GRAND TOTAL: =======
02-05-91 15:11 TRF International, Inc. PAGE 1
15-ED Wilson Const Adnd #3 Test Job
* * C O N S O L I D A T E D M A T E R I A L L I S T * *
PART NUMBER D E S C R I P T I O N QUANTITY FROM STOCK ORDERED
1 413PTYP0119 4"x5' Pipe CI SH P/ft 60 _______ _______
*PIPE CAST IRON SOIL B&S [413P]:
2 415PTYP0029 3"x10' Pipe CI NH P/ft 10 _______ _______
3 415PTYP0039 4"x10' Pipe CI NH P/ft 10 _______ _______
*PIPE CAST IRON SOIL NH [415P]:
4 462PCER0144 3/4" Pipe Cop L Hard 75 _______ _______
*TUBING COPPER WATER [462P]:
5 503PTYP0149 4" 1/4 Bend Hub 3 _______ _______
6 503PTYP0210 4" 1/4 Bend Long Swp Hub 1 _______ _______
7 503PTYP0415 4"x4" Y & 1/8 Bnd Hub 1 _______ _______
8 503PTYP0445 6"x4" Y & 1/8 Bnd Hub 1 _______ _______
*PIPE FITTINGS CAST IRON B&S [503P]:
9 505PTYP0020 4x4x10x16" Closet Bend PE NH 1 _______ _______
10 505PTYP0145 4" Bend 1/4 Reg NH 1 _______ _______
11 505PTYP0395 3"x2" Comb. Dbl Y & 1/8 NH 1 _______ _______
12 505PTYP0570 3" Coupling NH 1 _______ _______
*PIPE FITTINGS NO HUB [505P]:
13 543PNIB0070 3/4" Copper Union CxC 1 _______ _______
*TUBE FITTINGS COP PRESS CAST [543P]:
14 544PNIB0785 3/4" Cop 90 Ell CxC 4 _______ _______
15 544PNIB0885 3/4" Tee CxCxC 1 _______ _______
16 544PNIB1705 1/2x6" Air Chamber 1 _______ _______
*TUBE FITTINGS COP PRESS WROT [544P]:
17 581PITG0570 4" Dia Ins Shld 12"x18ga 11 _______ _______
18 581PITG1520 3" Hngr Clevis Blk 1 _______ _______
19 581PITG1550 4" Hngr Clevis Blk 11 _______ _______
20 581PMIH0055 10-1/2-PL REG HEX NUT 3 _______ _______
21 581PMIH0070 10-3/8-PL REG HEX NUT 32 _______ _______
22 581PMIH0250 11-1/2 ROUND FLAT WASHERS 3 _______ _______
23 581PMIH0265 11-3/8 ROUND FLAT WASHERS 32 _______ _______
24 581PMIH1180 355-PL STEEL CONCRETE INSERT 12 _______ _______
25 581PMIH1475 50-1/2-PL ALL THRD ROD P/FT 3 _______ _______
26 581PMIH1500 50-3/8-PL ALL THRD ROD P/FT 32 _______ _______
*PIPE HANGERS [581P]:
27 990PEXC0005A Exc 2'x3' trench <=5" pipe 60 _______ ______
*EXCAVATION & BACKFILL [990P]:
PULL DATE: ________ PULLED BY: ________ CHECKED BY: ________
02-01-91 11:19 TRF International, Inc. PAGE 1
15-ED Wilson Const Adnd #3 Test Job
* * C O N S O L I D A T E D M A T E R I A L L I S T * *
PART NUMBER D E S C R I P T I O N QUANTITY UNIT BID REMARKS
1 413PTYP0119 4"x5' Pipe CI SH P/ft 60 3.629 __________
*PIPE CAST IRON SOIL B&S [413P]:
2 415PTYP0029 3"x10' Pipe CI NH P/ft 10 2.139 __________
3 415PTYP0039 4"x10' Pipe CI NH P/ft 10 2.766 __________
*PIPE CAST IRON SOIL NH [415P]:
4 462PCER0144 3/4" Pipe Cop L Hard 75 .761 __________
*TUBING COPPER WATER [462P]:
5 503PTYP0149 4" 1/4 Bend Hub 3 6.893 __________
6 503PTYP0210 4" 1/4 Bend Long Swp Hub 1 10.619 __________
7 503PTYP0415 4"x4" Y & 1/8 Bnd Hub 1 12.965 __________
8 503PTYP0445 6"x4" Y & 1/8 Bnd Hub 1 21.348 __________
*PIPE FITTINGS CAST IRON B&S [503P]:
9 505PTYP0020 4x4x10x16" Closet Bend PE NH 1 16.877 __________
10 505PTYP0145 4" Bend 1/4 Reg NH 1 4.360 __________
11 505PTYP0395 3"x2" Comb. Dbl Y & 1/8 NH 1 8.349 __________
12 505PTYP0570 3" Coupling NH 1 1.662 __________
*PIPE FITTINGS NO HUB [505P]:
13 543PNIB0070 3/4" Copper Union CxC 1 1.650 __________
*TUBE FITTINGS COP PRESS CAST [543P]:
14 544PNIB0785 3/4" Cop 90 Ell CxC 4 .390 __________
15 544PNIB0885 3/4" Tee CxCxC 1 .726 __________
16 544PNIB1705 1/2x6" Air Chamber 1 1.140 __________
*TUBE FITTINGS COP PRESS WROT [544P]:
17 581PITG0570 4" Dia Ins Shld 12"x18ga 11 1.749 __________
18 581PITG1520 3" Hngr Clevis Blk 1 1.066 __________
19 581PITG1550 4" Hngr Clevis Blk 11 1.307 __________
20 581PMIH0055 10-1/2-PL REG HEX NUT 3 .054 __________
21 581PMIH0070 10-3/8-PL REG HEX NUT 32 .029 __________
22 581PMIH0250 11-1/2 ROUND FLAT WASHERS 3 .040 __________
23 581PMIH0265 11-3/8 ROUND FLAT WASHERS 32 .029 __________
24 581PMIH1180 355-PL STEEL CONCRETE INSERT 12 .623 __________
25 581PMIH1475 50-1/2-PL ALL THRD ROD P/FT 3 .378 __________
26 581PMIH1500 50-3/8-PL ALL THRD ROD P/FT 32 .238 __________
*PIPE HANGERS [581P]:
27 990PEXC0005A Exc 2'x3' trench <=5" pipe 60 ______ __________
*Excavation & Backfill [990P]:
* * * END OF LIST * * *
TRF International, Inc.
Date 02-06-91 S P E C I F I C A T I O N 15-ED Pg 1
Wilson Const Test Job Adnd #3
QUANTITY DESCRIPTION EACH EXTENDED
Underground Sanitary
60 4"X5' PIPE CI SH P/FT 12.896 773.80
3 4" 1/4 Bend Hub 38.646 115.94
1 4" 1/4 Bend Long Swp Hub 45.550 45.55
1 6"x4" Y & 1/8 Bnd Hub 99.160 99.16
1 4"x4" Y & 1/8 Bnd Hub 73.370 73.37
60 Exc 2'x3' trench <=5" pipe 7.200 432.00
Above Ground Sanitary
10 4"X10' PIPE CI NH P/FT 10.719 107.19
1 4" Bend 1/4 Reg NH 32.550 32.55
1 4x4x10x16" Closet Bend PE NH 48.470 48.47
10 3" CI NH 10ft w/HNGR 12.724 127.24
1 3"x2" Comb. Dbl Y & 1/8 NH 43.740 43.74
Domestic Cold Water
75 3/4" Cop L w/Hngr & Shld 12.161 912.12
4 3/4" Cop 90 Ell CxC 19.935 79.74
1 3/4" Tee CxCxC 28.640 28.64
1 1/2x6" Air Chamber 16.210 16.21
1 3/4" Copper Union CxC 21.540 21.54
SUPERVISION 350.00
Permits 100.00
Small Tools 235.00
Fixtures 9,995.80
Water Heaters 864.96
TOTAL BID PRICE: $14,503.02
==========
February 3, 1991
Wilson Construction, Inc.
924 West Ave.
Miami Beach, Florida, 33004
Attn: Mr. Jim Wilson
Ref : Test Job
Dear Mr. Wilson;
We are pleased to provide you the following proposal for the work described
on the Plans & Specifications Dated Jan 3, 1991.
Our quotation includes all amendments through Number 4 and includes the
following Scope of Work.
QTY DESCRIPTION OF WORK
Underground Sanitary
60 4"X5' PIPE CI SH P/FT
3 4" 1/4 Bend Hub
1 4" 1/4 Bend Long Swp Hub
1 6"x4" Y & 1/8 Bnd Hub
1 4"x4" Y & 1/8 Bnd Hub
60 Exc 2'x3' trench <=5" pipe
Above Ground Sanitary
10 4"X10' PIPE CI NH P/FT
1 4" Bend 1/4 Reg NH
1 4x4x10x16" Closet Bend PE NH
10 3" CI NH 10ft w/HNGR
1 3"x2" Comb. Dbl Y & 1/8 NH
Domestic Cold Water
75 3/4" Cop L w/Hngr & Shld
4 3/4" Cop 90 Ell CxC
1 3/4" Tee CxCxC
1 1/2x6" Air Chamber
1 3/4" Copper Union CxC
SUPERVISION
Permits
Small Tools
Fixtures
Water Heaters
TOTAL BID PRICE: $ 14,503.02
==========
